﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Jzy.Model.Mail
{
    public partial class WebMailAccountInfo
    {
        public const string INSERT_SQL = "insert into [WebMailAccount] ( [ID], [UserID], [DispName], [MailAddr], [Pop3Server], [Pop3Port], [Pop3User], [Pop3Pwd], [SmtpServer], [SmtpPort], [SmtpUser], [SmtpPwd], [SmtpAuthenicate], [ServerType], [IsDefault]) values ( @ID, @UserID, @DispName, @MailAddr, @Pop3Server, @Pop3Port, @Pop3User, @Pop3Pwd, @SmtpServer, @SmtpPort, @SmtpUser, @SmtpPwd, @SmtpAuthenicate, @ServerType, @IsDefault)";
        public const string UPDATE_SQL = "update [WebMailAccount] set  [ID] = @ID, [UserID] = @UserID, [DispName] = @DispName, [MailAddr] = @MailAddr, [Pop3Server] = @Pop3Server, [Pop3Port] = @Pop3Port, [Pop3User] = @Pop3User, [Pop3Pwd] = @Pop3Pwd, [SmtpServer] = @SmtpServer, [SmtpPort] = @SmtpPort, [SmtpUser] = @SmtpUser, [SmtpPwd] = @SmtpPwd, [SmtpAuthenicate] = @SmtpAuthenicate, [ServerType] = @ServerType, [IsDefault] = @IsDefault where ID = @ID";
        public WebMailAccountInfo() { }
        public Int32 ID
        {
            get;
            set;
        }
        public Int32 UserID
        {
            get;
            set;
        }
        public String DispName
        {
            get;
            set;
        }
        public String MailAddr
        {
            get;
            set;
        }
        public String Pop3Server
        {
            get;
            set;
        }
        public Int32 Pop3Port
        {
            get;
            set;
        }
        public String Pop3User
        {
            get;
            set;
        }
        public String Pop3Pwd
        {
            get;
            set;
        }
        public String SmtpServer
        {
            get;
            set;
        }
        public Int32 SmtpPort
        {
            get;
            set;
        }
        public String SmtpUser
        {
            get;
            set;
        }
        public String SmtpPwd
        {
            get;
            set;
        }
        public Boolean SmtpAuthenicate
        {
            get;
            set;
        }
        public Int32 ServerType
        {
            get;
            set;
        }
        public Boolean IsDefault
        {
            get;
            set;
        }
    }

}
